*	************************************************************************
* 	File-Name: 		CPS_AppendixC_balancetests.do
*
*	Data Used:  	trump_polls_aug12.dta version; JHU covid data; YouGov; Monmouth polls
*					fivethirtyeight; RMG polls; policy data from Raifman et al. (2020)
*
*	Purpose:   		.do file replicating Online Appendix F 
*	
*	************************************************************************


****************************************************************************
**Descriptive Statistics for data
****************************************************************************

clear all 
cd "/Users/alicezxu/Dropbox/Trump Polls/CPS Replication/Replication_final/Data/"
use CPS_trumppolls_final, clear

rename first_covid_date firstcase
gen weeks_since_firstcase = round(((start_date - firstcase) / 7), 1)

eststo clear
estpost summarize pct colgrad_perc non_teleworkable_emp essential_workers_perc weeks_since_firstcase after_business after_k12 after_emergency after_lock after_mask cumulative_cases Trump_pct_2016 popestimate2019 share_female share_black share_hispanic share_asian_hawaii_pacific mean_age
esttab using "covidtrump_sumstats.csv", replace label substitute(# \#) ///
    fragment nomtitle nonumber noobs cells("mean sd min max count(fmt(a2))")
	